﻿CREATE TABLE [dbo].[tblInventoryTransaction] (
    [InventoryTransactionID]         INT           IDENTITY (1, 1) NOT NULL,
    [InventoryTransactionTypeCode]   CHAR (1)      NOT NULL,
    [InventoryTransactionStatusCode] CHAR (1)      NOT NULL,
    [Qty]                            INT           NOT NULL,
    [InventoryID]                    INT           NOT NULL,
    [EffectiveDate]                  SMALLDATETIME NOT NULL,
    [Priority]                       INT           NULL,
    [OrderID]                        INT           NULL,
    [PackageID]                      INT           NULL,
	[RMAReturnID]		int		null,
	[UnitCost]			money	null,
	[DebitAccountID]	int		null,
	[CreditAccountID]	int		null,
	[TransactionID]		int 	null,
);

